﻿CREATE TABLE [dbo].[UDS_Task_Subscription] (
    [ID]            int         NOT NULL identity(1, 1),
    [TaskID]        int         NOT NULL,
    [Username]      nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [ExUsername]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
    [Date]          datetime    NOT NULL,
    [SubscribeDate] datetime    NULL CONSTRAINT [DF_UDS_Task_Subscription_SubscribeDate] default((getdate())),

    CONSTRAINT [PK_UDS_Task_Subscribe] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
